UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vBHG63ShQijs1zUMCYmfeIaDSLFxL59zU6GoDi2PN04='
WHERE
key_id = '58b8e2d8589ccb82e4683b87f5185d5db9f48b6afb9f01490c9ddcce5340f499'
AND (
token = 'vBHG63ShQijs1zUMCYmfeIaDSLFxL59zU6GoDi2PN04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)