UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zLJnwdDabCxJZdnrGDtdpFE8CYFF9Zm+scVqyujyQvQ='
WHERE
key_id = 'ab5ffff1c507da3109b1bfccd0ef18314ae457e4be61f30d4523c535e96c8ccb'
AND (
token = 'zLJnwdDabCxJZdnrGDtdpFE8CYFF9Zm+scVqyujyQvQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)