UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xgpIo/0o8PttOnG9uOBVy94X/N+ySM4F7jv6AhPKjbk='
WHERE
key_id = '4e55c000d3a7bbb366d96073bce38b0841733c5f6db223d80c69fdb7ba38229f'
AND (
token = 'xgpIo/0o8PttOnG9uOBVy94X/N+ySM4F7jv6AhPKjbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)