UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a1/R3+jqDN08pLvTysfunFPaEg+SaO9lfX+R+ABXNKg='
WHERE
key_id = '7c2e2484505711f302359a9ecf7b39cd46df8450a6594abc6152c2a9ae4ebe07'
AND (
token = 'a1/R3+jqDN08pLvTysfunFPaEg+SaO9lfX+R+ABXNKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)