UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6nuuEbK5DZ/9dOHzVW2y1uns6lcGXb+UWzo1j13Ec04='
WHERE
key_id = '30a0be3e83ebe76d05d8a51ed21a9e5b55a54f826afcb967b002dc71843f7e6b'
AND (
token = '6nuuEbK5DZ/9dOHzVW2y1uns6lcGXb+UWzo1j13Ec04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)