UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z2i8uTPLMXioltQutUjZxGV9dhhgNnOrsBm/orbkjvI='
WHERE
key_id = 'b333cd148bcf559d93086b4b3bafb377b63b2f6d23efd9a4421b679a5a035df5'
AND (
token = 'z2i8uTPLMXioltQutUjZxGV9dhhgNnOrsBm/orbkjvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)