UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dahoHGal5O1wgb5zEwv2moEvs2cscHukflXfTTZ460o='
WHERE
key_id = 'd7a49aae0ef7584a8a63d4e7eebd532cc504149f8d21265e49be5c3edbcb7ce5'
AND (
token = 'dahoHGal5O1wgb5zEwv2moEvs2cscHukflXfTTZ460o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)