UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/oV0rZeWSUw3e1b86PKKhH4ODPxPLfBMwaYGxkueZLc='
WHERE
key_id = 'c42079c1e0abe1e263eb9d627d78e93c7e08d0277fd0248755621fdfa0b56b5b'
AND (
token = '/oV0rZeWSUw3e1b86PKKhH4ODPxPLfBMwaYGxkueZLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)