UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sxpiy8/f0at0ff7zVgxU1t59voBZ74lPXLZf9V1o2i0='
WHERE
key_id = '3b2b29998bfc9a8156a2fab89fd4087959a17c5911b7ea4669ae9f2524643d8a'
AND (
token = 'sxpiy8/f0at0ff7zVgxU1t59voBZ74lPXLZf9V1o2i0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)