UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zmjk42nHexUFeGIX858QYGleU/SHHF+OYLxRTkg25NM='
WHERE
key_id = '1511ec7b047fb2783340328b042f5e5daee72f8f2af2e5deaa8a8cabc72ba487'
AND (
token = 'zmjk42nHexUFeGIX858QYGleU/SHHF+OYLxRTkg25NM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)