UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BTxRDBgGwpzbl/a/XSa9zv0MefBBGpzGa2TOXFzBbEk='
WHERE
key_id = '78a162c77718e0e59b4793a11a4fcd7ba62305d9e2b1c27441cc07b1054d0ae9'
AND (
token = 'BTxRDBgGwpzbl/a/XSa9zv0MefBBGpzGa2TOXFzBbEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)