UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kT3JdMxiAnWmzG0I9gRl+9U26QNEM0ZGjr0HB19Nyxs='
WHERE
key_id = 'b4c1ebc2acfa0cdda2e00a412813e1fe48d33ad3f00f37541addf1ff0d98db18'
AND (
token = 'kT3JdMxiAnWmzG0I9gRl+9U26QNEM0ZGjr0HB19Nyxs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)