UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nVYfptzwOkj6K21Bm7EL1hGIZEUWqtWC4LyG5dm67Dc='
WHERE
key_id = '12d12083db60af8d250c00b297d7ecf0e901f116e1fcc589917e74b185979f73'
AND (
token = 'nVYfptzwOkj6K21Bm7EL1hGIZEUWqtWC4LyG5dm67Dc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)