UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zxGkAl9XC3N2hIeQj1jgJN7WJWqgJBCEkgaGanrOqZk='
WHERE
key_id = '2956981f2ecd92e093dd76d2127f01b8a57205ce06ef3f483b172227a6d0be47'
AND (
token = 'zxGkAl9XC3N2hIeQj1jgJN7WJWqgJBCEkgaGanrOqZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)