UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gPp3WxbONVLluSQC91QPgb/b2Fzf1bxAagx8t66lTeU='
WHERE
key_id = 'f824eea74264793d28077d1c60fcba844286cb9a1bd13a1a9e72c069fb8ba3a2'
AND (
token = 'gPp3WxbONVLluSQC91QPgb/b2Fzf1bxAagx8t66lTeU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)