UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1fFyQTzZd8O96e4nma87udAHUum6wi+lW47RtbeTKqM='
WHERE
key_id = 'aa6c5305656543d9798674c9a7656c3e2ed35fb912f19b58fa5472f6596f5071'
AND (
token = '1fFyQTzZd8O96e4nma87udAHUum6wi+lW47RtbeTKqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)