UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L6a576tJeEZWkyT40qUa/g3Uyva28Tg/3FDPGkn0c4k='
WHERE
key_id = 'e1841a6e48f1bf713f5f8f28585d39808cd7b4e72fba693ad1a763b0829a2b5b'
AND (
token = 'L6a576tJeEZWkyT40qUa/g3Uyva28Tg/3FDPGkn0c4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)