UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hWKXSPXKOC9gWqzfK7z81wWZjqK4WuVJv6p5Hp95ih8='
WHERE
key_id = '1ccbb9b9b506fa17c7ffd22bb0ca1c1652a9d47bed2897c5bbe58ff7d4ecadaa'
AND (
token = 'hWKXSPXKOC9gWqzfK7z81wWZjqK4WuVJv6p5Hp95ih8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)