UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4+QjuwfMQTVr82nv20hH9gFvUlv43uFyMzUNE80nbw8='
WHERE
key_id = '3bfc7163d9546a5e3b46f2c6782080da811fed5e84d6d05071a22a92191faeaa'
AND (
token = '4+QjuwfMQTVr82nv20hH9gFvUlv43uFyMzUNE80nbw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)