UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P/5hooyuiMgPAi1otOHg5Kf3kagsCo5S9ymc2+M+bUI='
WHERE
key_id = '61b475372a572991f825c0ee8dec32b59e4adacfbeac01fa0ff7e07e293092e6'
AND (
token = 'P/5hooyuiMgPAi1otOHg5Kf3kagsCo5S9ymc2+M+bUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)