UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZBkkFI2+9EU8NKn980g1mUqeBXB3HLxMWAqWwwuHjgM='
WHERE
key_id = 'e8e44241891d583115133a17ab24204bb1cf742b046522a1647a04c870be8d0b'
AND (
token = 'ZBkkFI2+9EU8NKn980g1mUqeBXB3HLxMWAqWwwuHjgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)