UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b9WBI5B5Pv+8Rp2kAoFspIKFfh4P6xcIoofhGMO1wOo='
WHERE
key_id = 'c9ac53045d67619068586925e015953915c11ecf855210bab12d735dca968593'
AND (
token = 'b9WBI5B5Pv+8Rp2kAoFspIKFfh4P6xcIoofhGMO1wOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)