UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hgD0bxHU5DjlTiPOLg9n6zJiMw73zErcpSejnD3bj0w='
WHERE
key_id = '9e3f591c049e1235b2b733e250065c6bb57e6798341949907ca6c6354b13e99f'
AND (
token = 'hgD0bxHU5DjlTiPOLg9n6zJiMw73zErcpSejnD3bj0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)