UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3XSl9MJtsCnJcom1AxXr+8agjQYwCE1W14qjWxgVeI0='
WHERE
key_id = '3fffee4a526a02b3220bc354cd12df070707d8c9a59ad994501084ff7d14108b'
AND (
token = '3XSl9MJtsCnJcom1AxXr+8agjQYwCE1W14qjWxgVeI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)