UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'snjdmGNvVhSsujMjPyBtorC5NUgTSEuDrbixwRhpwLw='
WHERE
key_id = '7b7f1ee8d9023d2cfe848ed12027535ac0b4e19146e431233020d9714c8f8727'
AND (
token = 'snjdmGNvVhSsujMjPyBtorC5NUgTSEuDrbixwRhpwLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)