UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S8ufnRK6f7olSCyaBxNzA7ztZBI7NGvkZgoNWWtpNx4='
WHERE
key_id = 'b5aa875089a689365435a28f638562484cb3d69ecd49a02d1156aa9c26b30064'
AND (
token = 'S8ufnRK6f7olSCyaBxNzA7ztZBI7NGvkZgoNWWtpNx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)