UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ea3Jd53clxmirOfvf0nanysGt1TEiF6OAyawJBCq/yM='
WHERE
key_id = 'c47a64634ea3279c2b4ea81d41d6753cfe30c9158a63f34422e9e83f5b411ac4'
AND (
token = 'Ea3Jd53clxmirOfvf0nanysGt1TEiF6OAyawJBCq/yM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)