UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l0wnTtR35zOzIAwAd3/A2Icf4t42bqAKY636czup+k4='
WHERE
key_id = 'b894d6b65c2a8f26284962b12aba34d6460aa27daa1fc02988614a59fb1a7c74'
AND (
token = 'l0wnTtR35zOzIAwAd3/A2Icf4t42bqAKY636czup+k4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)