UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HIOU8jFAGFxABwpWP3wik6JSvt5p0e5zseahXOkg7XQ='
WHERE
key_id = '042f7b0d23eeb130b484c4d44f2db6bce20916c3225b73d87b72bac355fe0f45'
AND (
token = 'HIOU8jFAGFxABwpWP3wik6JSvt5p0e5zseahXOkg7XQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)