UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KKiCwaLBNSNlWkN9rFZnXOrOuFrad67rc6u5sORwPCo='
WHERE
key_id = '59d04b947117df92efd030ceb18fae6dfaf9778e15b376330289ffa8c4b6068f'
AND (
token = 'KKiCwaLBNSNlWkN9rFZnXOrOuFrad67rc6u5sORwPCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)