UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCEZvrSWOv2iIqyn6YgIN4v2Xj0vFZcufNIlL6t1edI='
WHERE
key_id = '871390f5841d5a50f1ea2b3234e8798a72c1e968ed7a8edf4bf5282e34af3428'
AND (
token = 'bCEZvrSWOv2iIqyn6YgIN4v2Xj0vFZcufNIlL6t1edI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)